Administrator Handbook | Table of contents |
Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language.
In the Following chapter we will see how to install:The MYSQL ODBC driver
MySQL ODBC driver installation
You should install the ODBC driver MyODBC 2.5 that fits with your Microsoft operating system. You will find all last version drivers and the documentation on the Web: http://dev.mysql.com/downloads/
The following example uses the Connector/ODBC 3.51 that we downloaded in an msi format.
MyODBC-3.51.11-2-win.msi
The next screen ask you to read the licence conditions.
Accept the conditions if you don't mind.
The next screen show the readme infos
The installation proceed and files are copied.
MySQL ODBC driver configuration
The Driver configuration can be done directly from LoriotPro or from the Microsoft Windows ODBC Data Source Administrator tool.
To access the ODBC Data Source Administrator tool, open the Control Panel, select Adminstrative Tools, the Data Source (ODBC).
The following screen is displayed:
If you have well installed the MySQL ODBC 3.51 driver you should see it in the driver tab.
DSN settingA Data Source Name should be created to allow LoriotPro to access to the SQL DataBase
What is a DSN: (Short for Data Source Name). Data Source Name provides connectivity to a database through an ODBC driver. The DSN contains database name, directory, database driver, UserID, password, and other information. Once you create a DSN for a particular database, you can use the DSN in an application to call information from the database.
There are three types of DSNs:
We choose to create a System DSN. We select the System DSN tab.
We cclick next on the Add button, a list of driver is displayed. We choose the MySQL ODBC driver.
The Connector ODBC windows setup is displayed.
You should enter the following parameters:
Data Source Name | A name used to identify this DSN |
Description | Description of this DSN |
Server | the Server name or IP address where the Database Server is installed |
User | The user name used to acces the Database |
Password | The Password of this user |
Database | The database name (Must be 'loriotpro') |
When the field are set you can check the connection to the datanase.
Click on the Test button.
Now the new DSN is available in the DSN list
You can leave the ODBC Data Source Administrator tool.
www.loriotpro.com |
|